export const tmptSqlCrudData = {
  "offsetX":-3278,
  "offsetY":-2790,
  "nodes":[
    {
      "name":"开始",
      "type":"controller-start-node",
      "id":"510c165a-6a75-9830",
      "x":3333,
      "y":2809
    },
    {
      "name":"UI保存入参",
      "type":"ui-in-param-node",
      "id":"5376e84a-d1ae-f8f3",
      "x":3451,
      "y":2870,
      "defineVarName":"dataParam",
      "defineVarInitData":"{\"name\":\"伍5\",\"sex\":\"1\",\"age\":\"34\",\"idcard\":\"342222222222222221\",\"mobile\":\"13222222222\",\"email\":\"22@dd.com\",\"address\":\"SH PUDONG \",\"taskFlowId\":1526087194268127200,\"route\":\"page\", pageStart:0,pageLimit:10,\"urlQueryData\":{\"dynamicFormId\":\"1515339064836816898\"}}",
      "description":"pageStart"
    },
    {
      "name":"路由",
      "type":"controller-route-node",
      "id":"cf842d93-94d4-8796",
      "x":3624,
      "y":2985
    },
    {
      "name":"JDBC取数",
      "type":"in-jdbc-node",
      "id":"2473f2f1-bb52-a6c1",
      "x":3552,
      "y":3164,
      "sql":"select * from ttf_test_employer where id=${dataParam.id}",
      "defineVarName":"dataList2",
      "description":""
    },
    {
      "name":"UI输出列表",
      "type":"ui-out-data-node",
      "id":"6872cb8e-f907-84cb",
      "x":3546,
      "y":3269,
      "defineVarName":"dataList2"
    },
    {
      "name":"结束",
      "type":"controller-end-node",
      "id":"65e8403f-ef79-7d26",
      "x":3578,
      "y":3430
    },
    {
      "name":"sql脚本-insert",
      "type":"code-sql-code-node",
      "id":"00a66e88-f6d2-5363",
      "x":3663,
      "y":3415,
      "script":"insert into ttf_test_employer(name, sex, age, idcard, mobile, email, address) values(${dataParam.name}, ${dataParam.sex}, ${dataParam.age}, ${dataParam.idcard}, ${dataParam.mobile}, ${dataParam.email}, ${dataParam.address});"
    },
    {
      "name":"结束",
      "type":"controller-end-node",
      "id":"1322301b-780a-6e5d",
      "x":3714,
      "y":3529
    },
    {
      "name":"sql脚本-update",
      "type":"code-sql-code-node",
      "id":"daa73499-fd0b-15aa",
      "x":4126,
      "y":3395,
      "script":"update ttf_test_employer set name=${dataParam.name}, sex=${dataParam.sex}, age=${dataParam.age}, idcard=${dataParam.idcard}, mobile=${dataParam.mobile}, email=${dataParam.email}, address= ${dataParam.address} where id=${idList[0].id}"
    },
    {
      "name":"结束",
      "type":"controller-end-node",
      "id":"bad3fc0a-f178-87f7",
      "x":4148,
      "y":3530
    },
    {
      "name":"JDBC分页",
      "type":"in-jdbc-page-node",
      "id":"a270afb9-3d67-376a",
      "x":3325,
      "y":3097,
      "sql":"select id, createdate as 'date', name, address as 'address' from test_user \n",
      "sqlWhere":"name like ${dataParam.name};\n",
      "sqlLimit":"order by id desc\nlimit ${dataParam.pageStart}, ${dataParam.pageLimit};",
      "defineVarName":"datalist",
      "defineVarName4PageTotal":"total",
      "sqlColumn":"select name, idcard, case sex when '1' then '男' else '女' end as sex, age, mobile, email, address from ttf_test_employer ",
      "sqlCount":"select count(1) from ttf_test_employer "
    },
    {
      "name":"结束",
      "type":"controller-end-node",
      "id":"1daa1dd2-fcd3-5f2b",
      "x":3296,
      "y":3427
    },
    {
      "name":"UI输出列表",
      "type":"ui-out-data-node",
      "id":"83d6c5c3-426e-d088",
      "x":3319,
      "y":3264,
      "defineVarName":"datalist",
      "defineVarName4PageTotal":"total"
    },
    {
      "name":"路由",
      "type":"controller-route-node",
      "id":"2de4fc3a-7b58-2e8d",
      "x":3897,
      "y":3273
    },
    {
      "name":"sql脚本-del",
      "type":"code-sql-code-node",
      "id":"762815ec-218d-5ecd",
      "x":4235.515625,
      "y":3091,
      "script":"update test_user set delete_flag=1 where id=${dataParam.id}"
    },
    {
      "name":"结束",
      "type":"controller-end-node",
      "id":"28da58ea-656b-643d",
      "x":4260,
      "y":3236
    },
    {
      "name":"JDBC取数",
      "type":"in-jdbc-node",
      "id":"090eadef-1602-5a83",
      "x":3831,
      "y":3081,
      "sql":"select id from ttf_test_employer where idcard=${dataParam.idcard}",
      "defineVarName":"idList"
    },
    {
      "name":"日志输出",
      "type":"out-log-node",
      "id":"eeae0879-f646-492f",
      "x":3848,
      "y":3180,
      "defineVarName":"idList"
    }
  ],
  "links":[
    {
      "id":"05e0fa85-870e-7c54",
      "connector":"Bezier",
      "sourceId":"510c165a-6a75-9830",
      "targetId":"5376e84a-d1ae-f8f3",
      "label":"",
      "isMethodBody":"",
      "type":"link"
    },
    {
      "id":"c31b0755-fc1a-414b",
      "connector":"Bezier",
      "sourceId":"cf842d93-94d4-8796",
      "targetId":"2473f2f1-bb52-a6c1",
      "label":"dataParam.route=='selectById'",
      "isMethodBody":"",
      "type":"link",
      "linkRouteCondition":"dataParam.route=='selectById'"
    },
    {
      "id":"dc567322-6cef-da6f",
      "connector":"Bezier",
      "sourceId":"2473f2f1-bb52-a6c1",
      "targetId":"6872cb8e-f907-84cb",
      "label":"",
      "isMethodBody":"",
      "type":"link"
    },
    {
      "id":"cf480670-88c1-e5d4",
      "connector":"Bezier",
      "sourceId":"6872cb8e-f907-84cb",
      "targetId":"65e8403f-ef79-7d26",
      "label":"",
      "isMethodBody":"",
      "type":"link"
    },
    {
      "id":"564c1b08-e9f3-4d95",
      "connector":"Bezier",
      "sourceId":"00a66e88-f6d2-5363",
      "targetId":"1322301b-780a-6e5d",
      "label":"",
      "isMethodBody":"",
      "type":"link"
    },
    {
      "id":"787581b6-2add-0e69",
      "connector":"Bezier",
      "sourceId":"daa73499-fd0b-15aa",
      "targetId":"bad3fc0a-f178-87f7",
      "label":"",
      "isMethodBody":"",
      "type":"link"
    },
    {
      "id":"f110a617-f3f9-9076",
      "connector":"Bezier",
      "sourceId":"cf842d93-94d4-8796",
      "targetId":"a270afb9-3d67-376a",
      "label":"dataParam.route=='page'",
      "isMethodBody":"",
      "type":"link",
      "linkRouteCondition":"dataParam.route=='page'"
    },
    {
      "id":"e652e967-78ff-89f4",
      "connector":"Bezier",
      "sourceId":"a270afb9-3d67-376a",
      "targetId":"83d6c5c3-426e-d088",
      "label":"",
      "isMethodBody":"",
      "type":"link"
    },
    {
      "id":"6b1db096-984f-9615",
      "connector":"Bezier",
      "sourceId":"83d6c5c3-426e-d088",
      "targetId":"1daa1dd2-fcd3-5f2b",
      "label":"",
      "isMethodBody":"",
      "type":"link"
    },
    {
      "id":"b5a4fc05-1892-1cc9",
      "connector":"Bezier",
      "sourceId":"2de4fc3a-7b58-2e8d",
      "targetId":"00a66e88-f6d2-5363",
      "label":"idList==null || idList.length==0",
      "isMethodBody":"",
      "type":"link",
      "linkRouteCondition":"idList==null || idList.length==0"
    },
    {
      "id":"77d9e33b-8e85-2c41",
      "connector":"Bezier",
      "sourceId":"2de4fc3a-7b58-2e8d",
      "targetId":"daa73499-fd0b-15aa",
      "label":"idList!=null && idList.length>0",
      "isMethodBody":"",
      "type":"link",
      "linkRouteCondition":"idList!=null && idList.length>0"
    },
    {
      "id":"b56b05ef-4f1b-198d",
      "connector":"Bezier",
      "sourceId":"cf842d93-94d4-8796",
      "targetId":"762815ec-218d-5ecd",
      "label":"dataParam.route=='delete'",
      "isMethodBody":"",
      "type":"link",
      "linkRouteCondition":"dataParam.route=='delete'"
    },
    {
      "id":"7735554b-df8c-1a8d",
      "connector":"Bezier",
      "sourceId":"762815ec-218d-5ecd",
      "targetId":"28da58ea-656b-643d",
      "label":"",
      "isMethodBody":"",
      "type":"link"
    },
    {
      "id":"8c7baeab-ee1e-fb8e",
      "connector":"Bezier",
      "sourceId":"5376e84a-d1ae-f8f3",
      "targetId":"cf842d93-94d4-8796",
      "label":"",
      "isMethodBody":"",
      "type":"link"
    },
    {
      "id":"18f3e262-3958-4d66",
      "connector":"Bezier",
      "sourceId":"cf842d93-94d4-8796",
      "targetId":"090eadef-1602-5a83",
      "label":"dataParam.route=='submit'",
      "isMethodBody":"",
      "type":"link",
      "linkRouteCondition":"dataParam.route=='submit'"
    },
    {
      "id":"46c275f4-389c-e354",
      "connector":"Bezier",
      "sourceId":"090eadef-1602-5a83",
      "targetId":"eeae0879-f646-492f",
      "label":"",
      "isMethodBody":"",
      "type":"link"
    },
    {
      "id":"5dd02eef-16ac-0029",
      "connector":"Bezier",
      "sourceId":"eeae0879-f646-492f",
      "targetId":"2de4fc3a-7b58-2e8d",
      "label":"",
      "isMethodBody":"",
      "type":"link"
    }
  ],
  "title":"",
  "label":"sss"
}
